Cerberus [SYSTEM] options
Listed below are the valid [SYSTEM]
options, in alphabetical order. Edit these settings using the Management Console's Engine
Configuration applet.
CTypeLocale
|
Description |
Sets the language locale to
use for upper, lower and proper case expressions and object names. |
Part |
CTypeLocale =
[VALUE]
|
Default |
English |
Remarks |
[VALUE] must be a valid language setting as
shown in Windows Control Panel's Regional and Language Options. When Engine starts up, the cerlog reports the language that has been selected. |
Example |
For example, the following
specification in the SYSTEM section of the Cerberus.ini file: CTypeLocale=German
results in this cerlog message:
[000003][03804] 06/09 16:15:18 INFORMATION
Changing ctype locale to : German_Germany.1252
|
LogFile
|
Description |
The path and file name of a log file that
Engine will output messages to. Usually, the file is called CERLOG.TXT. |
Part |
LOGFILE =
[VALUE]
|
Default |
The root of the current repository. |
MaxConnectionAttempts
|
Description |
The maximum number of attempts users
have to log in before their account is locked. |
Part |
MaxConnectionAttempts =
[VALUE]
Min = 0
Max = unlimited
|
Default |
3 |
MaxConnectionAttemptsSys
|
Description |
The maximum number of attempts System
users have to log in before their account is locked. |
Part |
MaxConnectionAttemptsSys =
[VALUE]
Min = 0
Max = unlimited
|
Default |
1000 |
NewNullRepresentation
|
Description |
If OFF, stores nulls in Real fields as -2130706432. If ON,
stores nulls in Real fields as -1.797693134862315807e308, this prevents any
ambiguity with negative numbers. |
Part |
NewNullRepresentation =
[VALUE]
0: OFF
1: ON
|
Default |
0: OFF |
Remarks |
It is recommended that this setting is set to ON for all new databases. It should not be altered once data
has been loaded.
See also: Data type limits and constraints.
|
NumericLocale
|
Description |
Specifies Locale numeric format for Engine
import and export. |
Part |
NumericLocale = [STRING]
Country code, for example, Spanish.
|
Default |
None. |
SparseArrays
|
Description |
If ON, allows the use of Sparse Arrays. |
Part |
SparseArrays =
[VALUE]
ON: Sparse
Arrays can be used
OFF: Sparse
Arrays cannot be used and the message "Not Enough Memory For Crosstab" may appear
in the cerlog.
|
Default |
OFF |
Remarks |
Sparse arrays are used when calculating
large crosstabs where many of the rows are blank and may be essential on larger
systems.
|
SystemDateFormat
|
Description |
Sets the System Date Format. This is the
format in which DATE fields are used in expressions and queries. |
Part |
SystemDateFormat =
[VALUE]
- 0 : CCYYMMDD
- 1 : DDMMCCYY
- 2 : CCYYDDMM
- 3 : MMDDCCYY
- 4 : DDMMYY
- 5 : MMDDYY
- 6 : DDMMMCCYY
|
Default |
1 |
Remarks |
All date fields must be re-imported if
the setting is changed, as it affects the internal storage.
|
SystemDateTimeFormat
|
Description |
Sets the System DateTime Format. This is the
format in which DATETIME fields are used in expressions and queries. |
Part |
SystemDateTimeFormat =
[VALUE]
- 00 : CCYYMMDD
HHMMSS
- 01 : CCYYMMDD
HHMM
- 02 : CCYYMMDD
HH:MM:SS
- 03 : CCYYMMDD
HH:MM
- 04 : DDMMCCYY
HHMMSS
- 05 : DDMMCCYY
HHMM
- 06 : DDMMCCYY
HH:MM:SS
- 07 : DDMMCCYY
HH:MM
- 08 : CCYYDDMM
HHMMSS
- 09 : CCYYDDMM
HHMM
- 10 : CCYYDDMM
HH:MM:SS
- 11 : CCYYDDMM
HH:MM
- 12 : MMDDCCYY
HHMMSS
- 13 : MMDDCCYY
HHMM
- 14 : MMDDCCYY
HH:MM:SS
- 15 : MMDDCCYY
HH:MM
- 16 : DDMMYY
HHMMSS
- 17 : DDMMYY HHMM
- 18 : DDMMYY
HH:MM:SS
- 19 : DDMMYY
HH:MM
- 20 : MMDDYY
HHMMSS
- 21 : MMDDYY HHMM
- 22 : MMDDYY
HH:MM:SS
- 23 : MMDDYY
HH:MM
- 24 : DDMMMCCYY
HHMMSS
- 25 : DDMMMCCYY
HHMM
- 26 : DDMMMCCYY
HH:MM:SS
- 27 : DDMMMCCYY
HH:MM
|
Default |
2 |
Remarks |
When DATETIME formats are passed as strings to Engine
(for example, in ITable.AddField or IField.Format), the colon (:) must be
replaced by a space ( ) or Engine will raise an Invalid Format error.
|
SystemTimeFormat
|
Description |
Sets the System Time Format. This is the
format in which TIME fields are used in expressions and queries. |
Part |
SystemTimeFormat =
[VALUE]
- 0 : HHMMSS
- 1 : HHMM
- 2 : HH:MM:SS
- 3 : HH:MM
|
Default |
2 |
Remarks |
The System Time Format will be overridden
by the User Format (see Cerberus: User) if the user format differs.
|
UnicodeLogFile
|
Description |
If ON, outputs log file information to a
unicode compliant log file. |
Part |
|
Default |
OFF |
Remarks |
By default, Engine's log file is in a
single byte ANSI format file. If Unicode is enabled and the database contains
double byte character object names, the log can be converted to Unicode
format by setting UnicodeLogFile = ON.
|
|
|